package net.misp.beta.nomilog.util;

public class StorePrefix {

	/*
	 * DIALOG_ID
	 */
	public static final int DIALOG_SEARCH = 0;
	public static final int DIALOG_REGIST = 1;
	public static final int DIALOG_CHECK = 2;
	public static final int DIALOG_DELETE = 3;
	public static final int DIALOG_NAVI = 4;

	/*
	 * SEARCH_MODE
	 */
	public static final int SEARCH_LIST = 0;
	public static final int SEARCH_MAP = 1;
	public static final int SEARCH_DATE = 2;

	/*
	 * MAP_MODE
	 */
	public static final int MAP_MAP = 0;
	public static final int MAP_NAVI = 1;
	public static final int MAP_NAVICON = 2;

	/*
	 * REGIST_MODE
	 */
	public static final int REGIST_FREE = 0;
	public static final int REGIST_QR = 1;

	/*
	 * PROVIDER
	 */
	public static final String PROVIDER_GPS = "gps";
	public static final String PROVIDER_WIFI = "wifi";

	/*
	 * DB
	 */
	public static final String DB_NAME = "store_db";
	public static final int DB_VERSION = 1;
	public static final String TABLE_NAME = "store";

	/*
	 * SQL_SELECT
	 */

	public static final String COLUMN_ID = "id";
	public static final String COLUMN_NAME = "name";
	public static final String COLUMN_GENRE = "genre";
	public static final String COLUMN_PRICE = "price";
	public static final String COLUMN_LATITUDE = "latitude";
	public static final String COLUMN_LONGITUDE = "longitude";
	public static final String COLUMN_ADDRESS = "address";
	public static final String COLUMN_TELEPHONE = "telephone";
	public static final String COLUMN_DATETIME = "datetime";
	public static final String COLUMN_MEMO = "memo";
	public static final String COLUMN_FAV = "fav";

	/*
	 * SQL_INSERT
	 */

	public static final int STMT_INSERT_NAME = 1;
	public static final int STMT_INSERT_GENRE = 2;
	public static final int STMT_INSERT_PRICE = 3;
	public static final int STMT_INSERT_LATITUDE = 4;
	public static final int STMT_INSERT_LONGITUDE = 5;
	public static final int STMT_INSERT_ADDRESS = 6;
	public static final int STMT_INSERT_TELEPHONE = 7;
	public static final int STMT_INSERT_DATETIME = 8;
	public static final int STMT_INSERT_MEMO = 9;
	public static final int STMT_INSERT_FAV = 10;

	/*
	 * SQL_UPDATE
	 */

	public static final int STMT_UPDATE_NAME = 1;
	public static final int STMT_UPDATE_GENRE = 2;
	public static final int STMT_UPDATE_PRICE = 3;
	public static final int STMT_UPDATE_LATITUDE = 4;
	public static final int STMT_UPDATE_LONGITUDE = 5;
	public static final int STMT_UPDATE_ADDRESS = 6;
	public static final int STMT_UPDATE_TELEPHONE = 7;
	public static final int STMT_UPDATE_DATETIME = 8;
	public static final int STMT_UPDATE_MEMO = 9;
	public static final int STMT_UPDATE_FAV = 10;
	public static final int STMT_UPDATE_ID = 11;

	/*
	 * SQL_DELETE
	 */

	public static final int STMT_DELETE_ID = 1;

	/*
	 * FLAG
	 */
	public static final String FLAG_NAME = "name";

}
